Microsoft
Microsoft Certified: Power BI Data Analyst Associate
PL-300: Power BI Data Analyst
PL-300: Advanced Modeling Technique in Power BI
it_dfdpbi_05_enus
PL-300: An Overview of Data Modeling in Power BI
it_dfdpbi_01_enus
PL-300: Analysis & Sharing Features in Power BI
it_dfapbi_01_enus
PL-300: Applying Power BI's Advanced Analysis Features
it_dfapbi_03_enus
PL-300: Applying the DAX Formula Language in Power BI
it_dfdpbi_02_enus
PL-300: Creating & Formatting Charts In Power BI
it_dfvpbi_02_enus
PL-300: Extracting Insights from Data Using Power BI
it_dfapbi_02_enus
PL-300: Leveraging Power BI with Ribbon, Line, Column, & Pie Charts
it_dfvpbi_03_enus
PL-300: Loading & Transforming Data in Power BI
it_dfppbi_02_enus
PL-300: Maps, Waterfall Charts, & Scatter Plots in Power BI
it_dfvpbi_04_enus
PL-300: Matrix & Treemap Controls in Power BI
it_dfvpbi_05_enus
PL-300: Preparing Data for Visualizations in Power BI
it_dfppbi_03_enus
PL-300: Sharing Power BI Reports & Workspaces
it_dfapbi_04_enus
PL-300: Understanding Data Visualization
it_dfvpbi_01_enus
PL-300: Using Power BI for Data Analysis
it_dfppbi_01_enus
PL-300: Using the Power BI Service
it_dfvpbi_06_enus
PL-300: Using Time Intelligence in Power BI
it_dfdpbi_04_enus
PL-300: Working with Filters in Power BI
it_dfdpbi_03_enus
Power BI Data Model Design: Advanced Modeling Technique
Lesson Objectives
Power BI Data Model Design: Advanced Modeling Technique
- discover the key concepts covered in this course
- load fact and dimension tables containing sales data for analysis
- recognize the types of relationships that Power BI can detect and apply automatically when data is loaded
- search for a value in a related table without establishing a relationship
- use bi-directional cross-filtering to perform an aggregation that is not possible with single-direction cross-filtering
- identify the types of cardinalities that can be applied to different types of relationships
- define a hierarchy of fields containing geographical information
- apply a geographical hierarchy in a Power BI visualization
- set the default aggregation on a field to compute the average
- combine related fields across tables into a single unit and configure them together
- recognize the benefits and limitations of Power BI's auto date/time feature
- create a table containing user information as a prelude to setting up row-level security
- set up permissions so that users can only view their own information when analyzing data with Power BI
- navigate over reports as different users in Power BI Desktop in order to ensure the correct implementation of row-level security
- summarize the key concepts covered in this course
Overview/Description
A well-designed data model eliminates irrelevant and uninterpretable analyses and ensures insightful and well-performing reports. Use this course to step up your data analysis using Power BI's advanced data modeling features. Begin by loading a sales dataset containing a large fact table and multiple dimension tables and modeling it into a snowflake schema. See how Power BI automatically detects relationships. Then, learn how to apply detailed configurations of relationships, from setting the right cardinality to applying bi-directional cross-filtering. Next, explicitly define a hierarchy in your data to model a set of geographical values. Learn further detailed configurations, such as setting a default aggregation operation on fields and hiding specific ones from the reports view. Lastly, learn how to implement row-level security. When you're done, you'll be able to use Power BI's advanced data modeling capabilities. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
A well-designed data model eliminates irrelevant and uninterpretable analyses and ensures insightful and well-performing reports. Use this course to step up your data analysis using Power BI's advanced data modeling features. Begin by loading a sales dataset containing a large fact table and multiple dimension tables and modeling it into a snowflake schema. See how Power BI automatically detects relationships. Then, learn how to apply detailed configurations of relationships, from setting the right cardinality to applying bi-directional cross-filtering. Next, explicitly define a hierarchy in your data to model a set of geographical values. Learn further detailed configurations, such as setting a default aggregation operation on fields and hiding specific ones from the reports view. Lastly, learn how to implement row-level security. When you're done, you'll be able to use Power BI's advanced data modeling capabilities. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
Power BI Data Model Design: An Overview of Data Modeling
Lesson Objectives
Power BI Data Model Design: An Overview of Data Modeling
- discover the key concepts covered in this course
- identify some of the critical steps involved in modeling data for analysis in Power BI
- recognize what the star schema is and why it's crucial in the context of data analysis in Power BI
- summarize the power of the DAX formula language and the types of operations it can perform
- describe the important techniques for optimizing data for performance when modeling data in Power BI
- use the UNION operation to combine the contents of two tables with identical schemas
- apply a DAX formula to compute a value based on existing data for each row in a table
- define a measure using the DAX formula language and contrast it with a calculated column
- create a simple table visual in order to view data stored in tables
- model a numeric value as a discrete rating on a 0-5 scale
- count the number of values in a column based on an expression
- summarize the key concepts covered in this course
Overview/Description
Data as a form of currency is an analogy that's been around since the early 2000s. However, data itself is worthless. The real value is in the insights you gain from it; this is where data analysis comes in. Data modeling is a crucial part of data analysis, helping turn raw data into accurate insights and meaningful reports. Use this course to learn how to design and optimize data models through Power BI Desktop. Examine the star and snowflake schemas. Learn about the DAX formula language. Then, conduct a range of tasks, including combining tables, defining calculated columns, creating measures, and counting values. Upon course completion, you'll know how to use data modeling to transform raw data into powerful visuals and reports. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Data as a form of currency is an analogy that's been around since the early 2000s. However, data itself is worthless. The real value is in the insights you gain from it; this is where data analysis comes in. Data modeling is a crucial part of data analysis, helping turn raw data into accurate insights and meaningful reports. Use this course to learn how to design and optimize data models through Power BI Desktop. Examine the star and snowflake schemas. Learn about the DAX formula language. Then, conduct a range of tasks, including combining tables, defining calculated columns, creating measures, and counting values. Upon course completion, you'll know how to use data modeling to transform raw data into powerful visuals and reports. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
DA-100: Analysis & Sharing Features in Power BI
Lesson Objectives
DA-100: Analysis & Sharing Features in Power BI
- discover the key concepts covered in this course
- recognize the different phases and roles involved when building and sharing Power BI reports
- identify the features available in Power BI to collaborate with other developers and share reports with end users
- describe the Power BI features available to develop and share reports and dashboards
- recall the steps involved in preparing for and taking the DA-100 certification exam for data analysis
- load a dataset into Power BI Desktop for analysis
- use a scatter chart to identify outliers in your dataset
- use a scatter chart to find outliers within categories of your dataset
- write a DAX expression to identify outliers
- summarize the key concepts covered in this course
Overview/Description
Analyzing data can throw light on game-changing insights. To action these insights, it's imperative the appropriate data is shared with the right people. Learn how to analyze and share data using Power BI in this DA-100 preparatory course. Explore considerations when building Power BI reports and collaborating with others. Learn how to streamline report deployment and sharing using Power BI pipelines, which help manage large and complex report deployments. And examine critical practices for securing reports by limiting the data accessible to viewers. Moving on, examine essentials to keep in mind when preparing for the DA-100 certification. Finally, get hands-on with Power BI Desktop, performing some preliminary analysis to identify outliers in your data. Upon completion, you'll know how to analyze data and share reports competently. You'll also be more prepared for the DA-100 certification exam.
Analyzing data can throw light on game-changing insights. To action these insights, it's imperative the appropriate data is shared with the right people. Learn how to analyze and share data using Power BI in this DA-100 preparatory course. Explore considerations when building Power BI reports and collaborating with others. Learn how to streamline report deployment and sharing using Power BI pipelines, which help manage large and complex report deployments. And examine critical practices for securing reports by limiting the data accessible to viewers. Moving on, examine essentials to keep in mind when preparing for the DA-100 certification. Finally, get hands-on with Power BI Desktop, performing some preliminary analysis to identify outliers in your data. Upon completion, you'll know how to analyze data and share reports competently. You'll also be more prepared for the DA-100 certification exam.
Target
Prerequisites: none
DA-100: Applying Power BI's Advanced Analysis Features
Lesson Objectives
DA-100: Applying Power BI's Advanced Analysis Features
- discover the key concepts covered in this course
- build a column chart to analyze the distribution of values across categories and the Analyze feature to identify situations where the distribution is different
- use the Analyze feature of line charts to explain plausible reasons for an increase or decrease in a metric
- apply the forecasting feature in a line chart to estimate future values based on past patterns
- find anomalies in a time series by using and configuring the anomaly detection feature in Power BI
- include and apply the Q&A visual in a report to enable users to extract insights by asking for it in plain English
- describe how query terms can be mapped to fields in a dataset for a Q&A visual
- construct a decomposition tree to analyze a metric across various categories
- summarize the key concepts covered in this course
Overview/Description
It can be overwhelming to think about analyzing data to meet all pre-defined requirements. Luckily, advancements in technology can help with this analysis. Learn to use the Power BI features made possible by AI and other advanced techniques in this demo-based course. Use Power BI's Analyze feature to understand values and metrics in sales data. Apply the forecasting feature to a line chart to estimate future sales. Then find outliers in terms of daily sales using the anomaly detection feature. Next, use the Q&A visual to allow users to extract insights from data using plain English. Finally, create a decomposition tree to break down the sales data across different categories. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
It can be overwhelming to think about analyzing data to meet all pre-defined requirements. Luckily, advancements in technology can help with this analysis. Learn to use the Power BI features made possible by AI and other advanced techniques in this demo-based course. Use Power BI's Analyze feature to understand values and metrics in sales data. Apply the forecasting feature to a line chart to estimate future sales. Then find outliers in terms of daily sales using the anomaly detection feature. Next, use the Q&A visual to allow users to extract insights from data using plain English. Finally, create a decomposition tree to break down the sales data across different categories. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
Target
Prerequisites: none
Power BI Data Model Design: Applying the DAX Formula Language
Lesson Objectives
Power BI Data Model Design: Applying the DAX Formula Language
- discover the key concepts covered in this course
- import multiple related tables into Power BI Desktop
- use the DAX language to calculate a sum of values based on an operation performed on raw data
- compute the average of a value derived from the data in a table
- use the BLANK function to generate blank values
- perform a variety of count operations using the different count functions available in DAX
- perform operations on a subset of data in a table
- define a DAX formula using nested IF function calls
- set the operations to be performed in different scenarios using the SWITCH function
- summarize the key concepts covered in this course
Overview/Description
Power BI does the heavy lifting when it comes to analyzing data. One way it does this is through the DAX formula language. By learning how to use this language, you can vastly improve the insights you get from data. Use this course to learn how to conduct several data analysis operations using the DAX formula language. Begin by performing aggregation operations, such as sum and average. Learn how to generate and work with blank data in DAX. Explore a variety of counting functions, ranging from simple counts of values to conditional counts based on filters. Lastly, practice using the IF and SWITCH functions. Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Power BI does the heavy lifting when it comes to analyzing data. One way it does this is through the DAX formula language. By learning how to use this language, you can vastly improve the insights you get from data. Use this course to learn how to conduct several data analysis operations using the DAX formula language. Begin by performing aggregation operations, such as sum and average. Learn how to generate and work with blank data in DAX. Explore a variety of counting functions, ranging from simple counts of values to conditional counts based on filters. Lastly, practice using the IF and SWITCH functions. Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
DA-100: Creating & Formatting Charts In Power BI
Lesson Objectives
DA-100: Creating & Formatting Charts In Power BI
- discover the key concepts covered in this course
- create a column chart in Power BI
- configure a column chart in Power BI
- format a column chart
- toggle and use options for a chart
- color the bars in a bar chart
- create column charts and bar charts
- visualize different types of data in Power BI
- import and transform data in Power Query
- create a line chart
- perform basic and top N filters
- implement advanced filters and create stacked area charts
- summarize the key concepts covered in this course
Overview/Description
Workhorse visualizations, such as line charts, column charts, and bar charts, are beneficial in all visualization use cases. Microsoft Power BI does a great job of making these common charts easy to put together and thoroughly customizable. Take this hands-on course to learn how to create and customize various chart types using Power BI. Learn how to create and customize column charts and bar charts from imported data. Explore how to import time-related data using Power Query and transform it into line charts. Then, experiment with multiple formatting operations on the line chart. Upon course completion, you'll be able to build line, bar, and column charts that are engaging and meaningful and be ready to learn how to create more advanced charts, including ribbon and pie charts. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Workhorse visualizations, such as line charts, column charts, and bar charts, are beneficial in all visualization use cases. Microsoft Power BI does a great job of making these common charts easy to put together and thoroughly customizable. Take this hands-on course to learn how to create and customize various chart types using Power BI. Learn how to create and customize column charts and bar charts from imported data. Explore how to import time-related data using Power Query and transform it into line charts. Then, experiment with multiple formatting operations on the line chart. Upon course completion, you'll be able to build line, bar, and column charts that are engaging and meaningful and be ready to learn how to create more advanced charts, including ribbon and pie charts. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
DA-100: Extracting Insights from Data Using Power BI
Lesson Objectives
DA-100: Extracting Insights from Data Using Power BI
- discover the key concepts covered in this course
- apply different summary statistics to obtain different metrics from your data
- recognize how duplicated numeric values can be aggregated in visuals
- create groups out of the existing categorical values in a table field
- edit, manage, and use customized groups in visuals
- create groups out of a numeric field by binning the data points
- identify clusters in your data by using the clusters feature in Power BI
- recognize how to interpret clusters in your data and tweak Power BI's clustering algorithm for your data
- use the play axis feature of a Power BI scatter chart to enable chart animation and explore data at different points in time
- analyze data over a time series using a line chart and a slicer
- find the values in a categorical field that have the greatest influence on a numeric field in your data
- identify key influencers across multiple fields in your dataset
- find the range of values in a numeric field that serves as key influencers for a metric
- summarize the key concepts covered in this course
Overview/Description
Getting insights from data isn't always straightforward. However, using a tool like Power BI helps with heavy lifting. Through this hands-on course, learn to obtain insights from data using a combination of Power BI's visualization and analysis features. Explore how and why numeric data is summarized. Discover how the sum, mean, and median statistics, among others, give different views of the same data. Practice modeling data into customized groups to better represent it to end users. Use scatter charts to identify clusters and enable analysis of snapshots of data with a play axis. Finally, use the key influencers visual to identify how certain metrics are influenced by values in other fields. Upon completion, you'll know how to take advantage of the analytics features of Power BI visuals. You'll also be more prepared for the DA-100 certification exam.
Getting insights from data isn't always straightforward. However, using a tool like Power BI helps with heavy lifting. Through this hands-on course, learn to obtain insights from data using a combination of Power BI's visualization and analysis features. Explore how and why numeric data is summarized. Discover how the sum, mean, and median statistics, among others, give different views of the same data. Practice modeling data into customized groups to better represent it to end users. Use scatter charts to identify clusters and enable analysis of snapshots of data with a play axis. Finally, use the key influencers visual to identify how certain metrics are influenced by values in other fields. Upon completion, you'll know how to take advantage of the analytics features of Power BI visuals. You'll also be more prepared for the DA-100 certification exam.
Target
Prerequisites: none
DA-100: Leveraging Power BI with Ribbon, Line, Column, & Pie Charts
Lesson Objectives
DA-100: Leveraging Power BI with Ribbon, Line, Column, & Pie Charts
- discover the key concepts covered in this course
- combine line and stacked column charts
- use and configure line and column charts
- create ribbon charts
- explore and navigate the hierarchy of a ribbon chart
- explore the drilldown functionality using a ribbon chart in Power BI
- visualize composition pie charts in Power BI
- create and use donut charts
- link a gauge and table
- create a calculated column in a table and color a gauge
- create funnel charts
- summarize the key concepts covered in this course
Overview/Description
In addition to the ubiquitous line, bar, and column charts, Microsoft Power BI supports other compelling visualizations. These include ribbon charts, a clever way to plot the evolution of both ranks and absolute quantities over time, and funnel charts, useful for representing a linear sequence of events. Advance your Power BI chart-building skills with this hands-on course. Learn how to visualize various kinds of data in the most beneficial way using line and stacked column charts (a combination of line charts and stacked column charts) as well as ribbon, pie, donut, and funnel charts. When you've finished this course, you'll be able to build both standard and specialized charts in Power BI. You'll then be ready to work with maps, waterfall charts, and scatter plots. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
In addition to the ubiquitous line, bar, and column charts, Microsoft Power BI supports other compelling visualizations. These include ribbon charts, a clever way to plot the evolution of both ranks and absolute quantities over time, and funnel charts, useful for representing a linear sequence of events. Advance your Power BI chart-building skills with this hands-on course. Learn how to visualize various kinds of data in the most beneficial way using line and stacked column charts (a combination of line charts and stacked column charts) as well as ribbon, pie, donut, and funnel charts. When you've finished this course, you'll be able to build both standard and specialized charts in Power BI. You'll then be ready to work with maps, waterfall charts, and scatter plots. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
Data Preparation and Processing: Loading & Transforming Data in Power BI
Lesson Objectives
Data Preparation and Processing: Loading & Transforming Data in Power BI
- discover the key concepts covered in this course
- download and install Power BI desktop
- connect to and import data from an Excel file into Power BI
- import data from CSV and XML files into Power BI and recall the role of Power Query in transforming the data
- load data from a JSON file into Power BI
- import data from a relational database and load it into Power BI
- remove unnecessary columns and rows from a data source using Power Query
- modify the types of columns in a table using Power Query
- merge the contents of two related columns in Power Query
- summarize the key concepts covered in this course
Overview/Description
Using Power BI for data analysis means you can pull data from multiple places into one location and turn that combined data into meaningful insights. Use this course to learn how to connect different data sources to Power BI and the types of transformations that can be applied to this data. Install Power BI desktop. Load data from CSV, XML, and JSON files as well as from SQL Server. Use Power Query within Power BI to apply transformations. Then, explore transformations crucial to building meaningful, responsive, and informative visualizations, such as trimming out unnecessary data and merging columns containing related information. Upon completion, you'll be able to load data into Power BI and transform it for analysis.
Using Power BI for data analysis means you can pull data from multiple places into one location and turn that combined data into meaningful insights. Use this course to learn how to connect different data sources to Power BI and the types of transformations that can be applied to this data. Install Power BI desktop. Load data from CSV, XML, and JSON files as well as from SQL Server. Use Power Query within Power BI to apply transformations. Then, explore transformations crucial to building meaningful, responsive, and informative visualizations, such as trimming out unnecessary data and merging columns containing related information. Upon completion, you'll be able to load data into Power BI and transform it for analysis.
Target
Prerequisites: none
DA-100: Maps, Waterfall Charts, & Scatter Plots in Power BI
Lesson Objectives
DA-100: Maps, Waterfall Charts, & Scatter Plots in Power BI
- discover the key concepts covered in this course
- create a map chart
- visualize geographical data using a map
- visualize sales data using a filled map
- drill through a map
- visualize toy sales for each state in the US with a filled map
- use a waterfall chart
- visualize profits over time with waterfall charts
- visualize data using a scatter plot
- summarize the key concepts covered in this course
Overview/Description
Microsoft Power BI is used in some of the world's largest enterprises. Its powerful map visualizations are great for representing global business data. Its waterfall charts benefit financial planners and analysts, while its scatter plots are ideal for data scientists. Through this practical course, learn how to use Power BI to visualize global business data. Work with Power BI maps, applying various customization techniques. Create waterfall charts for drilling through hierarchical data and representing cumulative processes. Then, create scatter charts to show the relationship between two variables and clusters within data. Lastly, use bubble charts to convey information via the size and color of each point in the chart. When you're done, you'll be able to use multiple advanced charts in Power BI and be ready to work with matrix and treemap controls. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Microsoft Power BI is used in some of the world's largest enterprises. Its powerful map visualizations are great for representing global business data. Its waterfall charts benefit financial planners and analysts, while its scatter plots are ideal for data scientists. Through this practical course, learn how to use Power BI to visualize global business data. Work with Power BI maps, applying various customization techniques. Create waterfall charts for drilling through hierarchical data and representing cumulative processes. Then, create scatter charts to show the relationship between two variables and clusters within data. Lastly, use bubble charts to convey information via the size and color of each point in the chart. When you're done, you'll be able to use multiple advanced charts in Power BI and be ready to work with matrix and treemap controls. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
DA-100: Matrix & Treemap Controls in Power BI
Lesson Objectives
DA-100: Matrix & Treemap Controls in Power BI
- discover the key concepts covered in this course
- create and group data using matrices
- use hierarchies in matrices
- filter and drill-through matrices
- format Power BI matrices
- apply conditional formatting to a matrix
- use icons as conditional formatting
- visualize the composition of a whole using treemaps
- filter, format, and drill through treemaps
- create hierarchical treemaps
- sync slicers and use them with treemaps
- create and sync slicers across multiple pages
- create slicers for numeric fields and horizontal slicers
- optimize a report for a mobile phone
- summarize the key concepts covered in this course
Overview/Description
As datasets grow larger and more complex, there is an ever-increasing need to organize data into categories and hierarchies. This is what the matrix and treemap controls in Power BI are designed to do. In this course, learn how to utilize matrices and treemaps to their full potential. Create a matrix widget and add aggregations. Create row and column hierarchies from hierarchical fields. Drill through hierarchical treemaps. And format matrices using color scales, data bars, and icons. Additionally, visualize the composition of a whole using treemaps. Learn how to create and filter data through slicers. And sync slicers across different pages and widgets in a report. Upon course completion, you'll have an advanced ability to use Power BI visualizations, ready to move on to using the Power BI service. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
As datasets grow larger and more complex, there is an ever-increasing need to organize data into categories and hierarchies. This is what the matrix and treemap controls in Power BI are designed to do. In this course, learn how to utilize matrices and treemaps to their full potential. Create a matrix widget and add aggregations. Create row and column hierarchies from hierarchical fields. Drill through hierarchical treemaps. And format matrices using color scales, data bars, and icons. Additionally, visualize the composition of a whole using treemaps. Learn how to create and filter data through slicers. And sync slicers across different pages and widgets in a report. Upon course completion, you'll have an advanced ability to use Power BI visualizations, ready to move on to using the Power BI service. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
Data Preparation and Processing: Preparing Data for Visualizations in Power BI
Lesson Objectives
Data Preparation and Processing: Preparing Data for Visualizations in Power BI
- discover the key concepts covered in this course
- connect to data sources that are related but stored in separate files and load them into Power BI
- use Power BI's column profiling feature to recognize what information is stored in a dataset
- perform a join operation to merge two related tables into a single unit
- load data from multiple separate but related files located in a single directory
- perform aggregations on data in a table to summarize the contents of a dataset
- apply the M formula language to perform data transformations in Power BI
- filter out unnecessary data by defining row-level filters
- create a basic column chart to visualize data in Power BI
- connect to a relational database in DirectQuery mode
- build a simple column chart from the contents of a Power BI table and distinguish between Import and DirectQuery storage modes in Power BI
- summarize the key concepts covered in this course
Overview/Description
A vital step between gathering data and creating a report or visualization from it is transforming it into a cohesive form. Use this course to gain hands-on experience in transforming raw data for visualizations. Practice combining related data into a single table. While doing so, perform a preliminary analysis of the data so you can imagine what visualizations can be created from it. Next, combine data from several files into a single table and conduct several transformations, from aggregating data to filtering out unnecessary rows. Finally, build a simple column chart visual from the contents of a Power BI table. While doing so, identify the different storage modes in Power BI and how they affect your visuals. Upon completion, you'll be able to prepare data for visualization using a variety of transformations.
A vital step between gathering data and creating a report or visualization from it is transforming it into a cohesive form. Use this course to gain hands-on experience in transforming raw data for visualizations. Practice combining related data into a single table. While doing so, perform a preliminary analysis of the data so you can imagine what visualizations can be created from it. Next, combine data from several files into a single table and conduct several transformations, from aggregating data to filtering out unnecessary rows. Finally, build a simple column chart visual from the contents of a Power BI table. While doing so, identify the different storage modes in Power BI and how they affect your visuals. Upon completion, you'll be able to prepare data for visualization using a variety of transformations.
Target
Prerequisites: none
DA-100: Sharing Power BI Reports & Workspaces
Lesson Objectives
DA-100: Sharing Power BI Reports & Workspaces
- discover the key concepts covered in this course
- add a new table to your Power BI model to map users to specific categories of data they can access
- implement and test row-level security in Power BI Desktop
- publish a report to a Power BI workspace and create an app for the workspace
- verify the implementation of row-level security when sharing an app with end users
- set varying levels of permissions on a Power BI workspace and recognize what operations are possible for each role
- allow users to access multiple categories of data when setting up row-level security
- map a workspace to the development stage of a Power BI pipeline and explore the lineage view of a workspace
- recall the steps involved in migrating to the different stages of a Power BI pipeline
- recognize the use cases for endorsing Power BI reports and dashboards
- use the performance analyzer feature in Power BI Desktop to identify potential performance bottlenecks in reports
- summarize the key concepts covered in this course
Overview/Description
Analyzing data and building reports is only useful if the right people can access and understand those reports. Take this course to learn how to involve others in your Power BI reports, be it collaborators in report development or consumers of your analysis. Begin by building a report configured with row-level security. Then, test it in Power BI Desktop before publishing it to the Power BI service. Via the Power BI service, share your workspace with teammates and other collaborators using different roles and permissions. Then use the Pipeline feature to streamline report deployment. Finally, learn to enhance report performance and collaboration by adding endorsements and using the native performance analyzer. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
Analyzing data and building reports is only useful if the right people can access and understand those reports. Take this course to learn how to involve others in your Power BI reports, be it collaborators in report development or consumers of your analysis. Begin by building a report configured with row-level security. Then, test it in Power BI Desktop before publishing it to the Power BI service. Via the Power BI service, share your workspace with teammates and other collaborators using different roles and permissions. Then use the Pipeline feature to streamline report deployment. Finally, learn to enhance report performance and collaboration by adding endorsements and using the native performance analyzer. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
Target
Prerequisites: none
DA-100: Understanding Data Visualization
Lesson Objectives
DA-100: Understanding Data Visualization
- discover the key concepts covered in this course
- summarize why data visualization is used
- list and describe the purpose of different kinds of visualizations
- outline when to use tables, matrices, and column charts in Power BI
- outline best practices for using line charts, pie charts, bubble charts, and scatter charts
- list and describe the specialized charts in Power BI
- outline the purpose of Power BI reports and how to design them, with reference to features and best practices
- summarize the key concepts covered in this course
Overview/Description
Microsoft Power BI is a powerful and versatile visualization technology widely used in data analytics, especially business data analysis. Business analysts can use this service to build and publish interactive reports for executive audiences as well as collaborators. Get your head around the specifics of data visualization in this introductory course. Explore different types of visualizations and their use-cases, covering standard charts and those for more specific cases. Learn about the structure of Power BI and how it helps with data visualization. Then, examine report creation in Power BI. When you've finished, you'll understand the theory behind data visualization in Power BI and be ready to move on to creating and formatting charts in Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Microsoft Power BI is a powerful and versatile visualization technology widely used in data analytics, especially business data analysis. Business analysts can use this service to build and publish interactive reports for executive audiences as well as collaborators. Get your head around the specifics of data visualization in this introductory course. Explore different types of visualizations and their use-cases, covering standard charts and those for more specific cases. Learn about the structure of Power BI and how it helps with data visualization. Then, examine report creation in Power BI. When you've finished, you'll understand the theory behind data visualization in Power BI and be ready to move on to creating and formatting charts in Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
Data Preparation and Processing: Using Power BI for Data Analysis
Lesson Objectives
Data Preparation and Processing: Using Power BI for Data Analysis
- discover the key concepts covered in this course
- list the Power BI data analysis skills tested in the DA-100 certification exam
- outline the steps involved before, during, and after taking the DA-100 certification exam
- define what's meant by data analysis, distinguish it from business analytics, describe some of the crucial tasks involved in this process, and name several types of analytics
- identify the different job roles involved in data analysis and summarize the scope of each role
- list the tasks involved in data analysis that result in the transformation of raw data into meaningful visuals and reports
- recognize the features and components of Power BI used to simplify data analysis tasks
- recall the primary features and capabilities of Power BI and summarize how they facilitate data analysis tasks
- summarize the key concepts covered in this course
Overview/Description
Most businesses have an enormous amount of data in their possession. But this data is only as valuable as the quality of the processes used to understand it. So how do you gather seemingly disparate data from multiple sources and turn it into digestible insights for all to use? One way to do this is to use Power BI, Microsoft's business analytics service. Use this course to comprehend exactly what's involved in data analysis, including specific tasks and job roles. Examine how Power BI's suite of features can facilitate these tasks efficiently and effectively. Furthermore, see the steps involved in taking the DA-100 certification exam, which tests the learner's ability to analyze data using Power BI. Upon completion, you'll have a theoretical understanding of how Power BI is used to carry out data analysis.
Most businesses have an enormous amount of data in their possession. But this data is only as valuable as the quality of the processes used to understand it. So how do you gather seemingly disparate data from multiple sources and turn it into digestible insights for all to use? One way to do this is to use Power BI, Microsoft's business analytics service. Use this course to comprehend exactly what's involved in data analysis, including specific tasks and job roles. Examine how Power BI's suite of features can facilitate these tasks efficiently and effectively. Furthermore, see the steps involved in taking the DA-100 certification exam, which tests the learner's ability to analyze data using Power BI. Upon completion, you'll have a theoretical understanding of how Power BI is used to carry out data analysis.
Target
Prerequisites: none
DA-100: Using the Power BI Service
Lesson Objectives
DA-100: Using the Power BI Service
- discover the key concepts covered in this course
- set up the Power BI service
- pin visuals to a dashboard
- live-pin an entire report to a dashboard
- use the Q&A feature in a Power BI dashboard
- pin a graph from one dashboard to another and change the mobile layout
- summarize the key concepts covered in this course
Overview/Description
Microsoft was a pioneer in desktop applications. But when it adapted to the cloud, it had spectacular success. Similarly, Microsoft's Power BI service has a powerful desktop app in addition to a multifunctional web service. Learn to use the Power BI web service in this hands-on course. Start with publishing reports for other people to view. Then pin visualizations and reports to a dashboard, even live-pinning an entire report to the dashboard. Finally, learn how to use various dashboard features, including the Q&A, which uses natural language processing to answer queries about your data. When you're done, you'll be able to leverage the Power BI Software as a Service and be ready to move on to analyzing and sharing data through Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Microsoft was a pioneer in desktop applications. But when it adapted to the cloud, it had spectacular success. Similarly, Microsoft's Power BI service has a powerful desktop app in addition to a multifunctional web service. Learn to use the Power BI web service in this hands-on course. Start with publishing reports for other people to view. Then pin visualizations and reports to a dashboard, even live-pinning an entire report to the dashboard. Finally, learn how to use various dashboard features, including the Q&A, which uses natural language processing to answer queries about your data. When you're done, you'll be able to leverage the Power BI Software as a Service and be ready to move on to analyzing and sharing data through Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
Target
Prerequisites: none
Power BI Data Model Design: Using Time Intelligence
Lesson Objectives
Power BI Data Model Design: Using Time Intelligence
- discover the key concepts covered in this course
- define a date table to represent a date using a variety of dimensions and formats
- set a relationship between a date table and a fact table
- modify the range of dates in the current context using the DATEADD function
- perform year-to-date and month-to-date computations on data by altering the current context
- calculate the year-to-date sales values using the TOTALYTD function
- summarize the key concepts covered in this course
Overview/Description
A big part of data analysis is evaluating how data behaves over time. Power BI's DAX language includes time intelligence functions that enable you to aggregate, compare, and manipulate data using time periods. Use this course to learn how to model data using time-based analysis. Begin by creating a date table. Then use DAX time intelligence functions to extract values from a date. Also, learn how to define dates as a hierarchy, which can then be applied in visualizations. Moving along, practice operating on a range of dates that are shifted from the range in the current context by a specified interval. Finally, perform year-to-date and month-to-date computations from the date in the current context. When you're done, you'll be able to apply a variety of time functions to your data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
A big part of data analysis is evaluating how data behaves over time. Power BI's DAX language includes time intelligence functions that enable you to aggregate, compare, and manipulate data using time periods. Use this course to learn how to model data using time-based analysis. Begin by creating a date table. Then use DAX time intelligence functions to extract values from a date. Also, learn how to define dates as a hierarchy, which can then be applied in visualizations. Moving along, practice operating on a range of dates that are shifted from the range in the current context by a specified interval. Finally, perform year-to-date and month-to-date computations from the date in the current context. When you're done, you'll be able to apply a variety of time functions to your data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
Power BI Data Model Design: Working with Filters
Lesson Objectives
Power BI Data Model Design: Working with Filters
- discover the key concepts covered in this course
- use a common column to set a relationship between tables loaded into Power BI
- perform an aggregation using a key from one table and values from another related table
- define a table using the contents of another table by setting a filter context
- perform operations on a subset of data by defining a filter context
- set up a DAX function to ignore a filter context for a specific calculation
- use the ALL function to access all rows in a table by ignoring the filter context
- apply the ALLSELECTED function to ignore the context set by a visualization
- employ DAX functions to ignore the query context set by Power BI visualizations
- summarize the key concepts covered in this course
Overview/Description
The more you master DAX in Power BI, the better the insights and reports you'll get from data. The filter context is a need-to-know DAX concept. Use this course to get hands-on experience working with this aspect of Power BI. Start by exploring the relationships between tables in Power BI. Move on to using the CALCULATE function. Then, see how a filter context can be defined so that it only points to a subset of the overall data and how you can continue to perform operations within this filter context. Moving on, examine a breadth of options for ignoring the filter context for specific use cases, including how to bypass filters using various DAX functions. When you're done, you'll be able to use DAX functions to perform operations on a subset of data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
The more you master DAX in Power BI, the better the insights and reports you'll get from data. The filter context is a need-to-know DAX concept. Use this course to get hands-on experience working with this aspect of Power BI. Start by exploring the relationships between tables in Power BI. Move on to using the CALCULATE function. Then, see how a filter context can be defined so that it only points to a subset of the overall data and how you can continue to perform operations within this filter context. Moving on, examine a breadth of options for ignoring the filter context for specific use cases, including how to bypass filters using various DAX functions. When you're done, you'll be able to use DAX functions to perform operations on a subset of data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
Target
Prerequisites: none
